if exists (select name from sysobjects where name like 'Proc_LoaiKyHanLS_GetById')
	drop procedure Proc_LoaiKyHanLS_GetById
go

create PROC Proc_LoaiKyHanLS_GetById (@maLoaiKyHanLS int )
as
	select * from LoaiKyHanLS
	where @maLoaiKyHanLS= LoaiKyHanLS.MaLoaiKHLS
go

Exec Proc_LoaiKyHanLS_GetById 1
go